package com.atguigu.dga.governance.mapper;

import com.atguigu.dga.governance.bean.GovernanceAssessTecOwner;
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 技术负责人治理考评表 Mapper 接口
 * </p>
 *
 * @author tubage
 * @since 2024-03-22
 */
@Mapper
@DS("dga")
public interface GovernanceAssessTecOwnerMapper extends BaseMapper<GovernanceAssessTecOwner> {

    @Select("select\n" +
            "    assess_date,\n" +
            "    tec_owner,\n" +
            "    avg(score_spec_avg * 10) score_spec,\n" +
            "    avg(score_storage_avg * 10) score_storage,\n" +
            "    avg(score_calc_avg * 10) score_calc,\n" +
            "    avg(score_quality_avg * 10) score_quality,\n" +
            "    avg(score_security_avg * 10) score_security,\n" +
            "    avg(score_on_type_weight) score,\n" +
            "    count(table_name) table_num,\n" +
            "    sum(problem_num) problem_num,\n" +
            "    now() create_time\n" +
            "    from governance_assess_table\n" +
            "where assess_date = #{assessDate}\n" +
            "group by assess_date, tec_owner")
    public List<GovernanceAssessTecOwner> selectGovernanceAssessTecOwnerList(String assessDate);
}
